UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bzyzwNv2oMfojdWC4Nv5QcZL4L/s1Asw0JHGkJvFLBg='
WHERE
key_id = 'a0c65937f2bd191f5baf1c4aef04d5bd74ef0e071414367d11258b8b1d2486bf'
AND (
token = 'bzyzwNv2oMfojdWC4Nv5QcZL4L/s1Asw0JHGkJvFLBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)