UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'smh5pliANqqh4grFlgKDb1CO0nQE9sKkpYdMxAILv6I='
WHERE
key_id = 'efe5ae172e335df1e8c446d84d161aef08a9808f7e9c0dad100cb4e978f3cb2b'
AND (
token = 'smh5pliANqqh4grFlgKDb1CO0nQE9sKkpYdMxAILv6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)