UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dSR+IYsIhVfHlMizL6de10TnS6B78HSRKVqkZUqChRg='
WHERE
key_id = 'ca5cccb1fb73f536dfd82e5293ef172a7d68899163da70a00c27751cd704b606'
AND (
token = 'dSR+IYsIhVfHlMizL6de10TnS6B78HSRKVqkZUqChRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)