UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BK2LrKY/2FYuOEnjs6J6zCWIvwBqREmT/q9KsiJfsUU='
WHERE
key_id = 'e2720d82b0ccc69078224208a0759ada4a60a14307121236467620fc9b633d44'
AND (
token = 'BK2LrKY/2FYuOEnjs6J6zCWIvwBqREmT/q9KsiJfsUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)