UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bC38EAjVXe0K6o7IhwkHL+PVsA8fUOg1TSzBYBqLLCM='
WHERE
key_id = 'be7d4475798ed391b0160fbe19fe84064a0dde65883d5c97a5bae7537378310f'
AND (
token = 'bC38EAjVXe0K6o7IhwkHL+PVsA8fUOg1TSzBYBqLLCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)