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