UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hGpD1rysB4s6X0Y56s/M7vCGXikY3qBktNE7OYxk3Io='
WHERE
key_id = 'd223cc58770be7b8108bda12fabe4094d3c63867e5a05ddc5d12a91fb6d907dc'
AND (
token = 'hGpD1rysB4s6X0Y56s/M7vCGXikY3qBktNE7OYxk3Io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)