UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ie6fDHJs31UKjKkmrF6EAC8F2KCw36VdTjSkizkPgK8='
WHERE
key_id = 'f78fbb1d589eec57b7f3b6db65095046eb901a5bbed312ee80bd3ad12e0ad1df'
AND (
token = 'ie6fDHJs31UKjKkmrF6EAC8F2KCw36VdTjSkizkPgK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)