UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lWth5a3+yJqGXm6PqhlfbsTpaUIbPcHI5MXe3hHCKKE='
WHERE
key_id = 'bcaefef90c8985e7b83539ab83870a0cb6d01b5ed0aefdf033a6af5d2755576e'
AND (
token = 'lWth5a3+yJqGXm6PqhlfbsTpaUIbPcHI5MXe3hHCKKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)