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