UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z25vL8keAyOSNl/kniUtPI7kBFdYrhFocEXmVrm5Y7M='
WHERE
key_id = '3927e3602f2650fd8436929939986be43e2eb1330642d9a1922ae53644d3ee2a'
AND (
token = 'z25vL8keAyOSNl/kniUtPI7kBFdYrhFocEXmVrm5Y7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)