UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XS1+9FsN100yk5WiXBDMwr28JVWyPYZDFejry5DW38='
WHERE
key_id = 'fd51527bb81984e73b52e6de9f5b80b25884951ef6335be92e57694b014167a8'
AND (
token = '4XS1+9FsN100yk5WiXBDMwr28JVWyPYZDFejry5DW38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)