UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0YgDSi4YGefFOR7nJqLn7hqlY4pfu2XpoO3SB2JeqA4='
WHERE
key_id = '5d8045cbd0120c49932f4b196195d333d93ff718bc847d6e863cba2213810c82'
AND (
token = '0YgDSi4YGefFOR7nJqLn7hqlY4pfu2XpoO3SB2JeqA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)