UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7yXAYtNqb5Yl/My+dXYV4nFz4FsLuyWM6U+jbElTOCw='
WHERE
key_id = 'bdec14e7fb260377f5fa3f64ecead2a0d77f339c3fc0e9910598ddc6bf696aa1'
AND (
token = '7yXAYtNqb5Yl/My+dXYV4nFz4FsLuyWM6U+jbElTOCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)