UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3FLOMpDFhM4+XJsuJsIiUTUScesTcsTSMNLBF62XOVM='
WHERE
key_id = 'd968431c0f3c78807f84341df784e8744bd1c48c236027e690ab33211cc1bcf2'
AND (
token = '3FLOMpDFhM4+XJsuJsIiUTUScesTcsTSMNLBF62XOVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)