UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yP2r3stibc602/a4hUkPweYaa4UL1DVw384dlgyC9xc='
WHERE
key_id = 'dd449ea66424f77b4eab480a25da89a8a809015df22c285c3d8205823ce494b0'
AND (
token = 'yP2r3stibc602/a4hUkPweYaa4UL1DVw384dlgyC9xc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)