UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TIiY/A0uLSp/fG2yesX42unEX4COR5FuCgH3iI4M2UU='
WHERE
key_id = 'b586c765ad91cb2d8b83ce793f050cec43269daaedd23ebf9ba113df1bae4738'
AND (
token = 'TIiY/A0uLSp/fG2yesX42unEX4COR5FuCgH3iI4M2UU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)