UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P8d4nLMMm0scuHIGQcJrOoPYyH5+8kMGJmLNzzlggXM='
WHERE
key_id = '488bd76325891808dcdf676f151137ee37afe55b27561a5f3888a18784db96ec'
AND (
token = 'P8d4nLMMm0scuHIGQcJrOoPYyH5+8kMGJmLNzzlggXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)