UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nJDSP+zU99ONGdTu+8xouLBGUFmmzj+rrMmaUpxJhII='
WHERE
key_id = '52dfa667de57f5d7f64d1584c078e14e39683365183349b7b480e66ce8f41f20'
AND (
token = 'nJDSP+zU99ONGdTu+8xouLBGUFmmzj+rrMmaUpxJhII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)