UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hv6SWQJAPHjMv2j3kbxatWmS7nEm0ONj+tf/jnMxsIg='
WHERE
key_id = '47281574bb772381015f2f98d3f444289d2f276e25412c94fd7508f0d36814c9'
AND (
token = 'hv6SWQJAPHjMv2j3kbxatWmS7nEm0ONj+tf/jnMxsIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)