UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XMTjxvcs3YbL6Y7PXpm3XEGwGljDWHErj0V0h4xCRs='
WHERE
key_id = '31ec086535a71e07b3752b35be43d9b68e70400b9dc253ab3b7c4066ac9797e5'
AND (
token = '4XMTjxvcs3YbL6Y7PXpm3XEGwGljDWHErj0V0h4xCRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)