UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dy3/rlknYaXI29j2EufJYB6N0hqv/6rahgoqHDXN6oU='
WHERE
key_id = 'b971f58d891fbeae8ebee530cf6c327dbc1435c159ba900b36e4a2d9a5ec474d'
AND (
token = 'dy3/rlknYaXI29j2EufJYB6N0hqv/6rahgoqHDXN6oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)