UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P2Zz3xb52UC6qiwfxgw9yun1U15bsCM3bXXje9a9Pzk='
WHERE
key_id = '5050071db0b7f91f3cb78641be9a9c3190e5d49494ac7d383775178626e93b8a'
AND (
token = 'P2Zz3xb52UC6qiwfxgw9yun1U15bsCM3bXXje9a9Pzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)