UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cL0FJzIkjOxMQblPnv89miDEtQzZyw04GSap6MvOPvI='
WHERE
key_id = 'ccb58bf47728f22d2813b0269f8277d6a8e726b008b019cee406d70859a87be9'
AND (
token = 'cL0FJzIkjOxMQblPnv89miDEtQzZyw04GSap6MvOPvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)