UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nfpp1AdzMgVooshFJnFvbhlw4VmCSFi/r2U+2i6yhwk='
WHERE
key_id = '4de2d1adba8a832803c260a88916d3d4b517ea025166820f8811d550d23001d4'
AND (
token = 'Nfpp1AdzMgVooshFJnFvbhlw4VmCSFi/r2U+2i6yhwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)