UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6x5RhCAb+3Blu8Vz3dCGeVw4Ik8jMz6e1/KNS959u9E='
WHERE
key_id = '5b05d1c7943a1b828f5d9c453ebedfb8273254c6600911001fdabb930a427b31'
AND (
token = '6x5RhCAb+3Blu8Vz3dCGeVw4Ik8jMz6e1/KNS959u9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)