UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PY1/UtRa3HDwf3BTqF4NT9Mb2r8qnE5fyW44g7w4XA4='
WHERE
key_id = '28a594a0ecc90d832362ab0f621a31c3d68398769950789493b639c86e3f3e51'
AND (
token = 'PY1/UtRa3HDwf3BTqF4NT9Mb2r8qnE5fyW44g7w4XA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)