UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHktKt7yvqab6ByAP0tlb4Kf6J0LP+IUpLedvVepWrw='
WHERE
key_id = 'bfc81b369dd23b0a93d96fed5241e16252dad529d48895c1bc73ea2d9966128a'
AND (
token = 'pHktKt7yvqab6ByAP0tlb4Kf6J0LP+IUpLedvVepWrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)