UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ggLkXzsXXn3LC8qIT82fyuRpNc3L0vlunri41u6fxFs='
WHERE
key_id = '3cf15de45f6f6388dfc66064e0810890bf949f416884266ba4dee5778e27fa7a'
AND (
token = 'ggLkXzsXXn3LC8qIT82fyuRpNc3L0vlunri41u6fxFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)