UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/cD+S/ZuNc4QR0HS+NkP3voEt7Z5pktb5zyKtV9NHDM='
WHERE
key_id = 'aecae32f1199278ffdbd1152c3af93ead6ca9ae18cc08a1647c2098d3621a543'
AND (
token = '/cD+S/ZuNc4QR0HS+NkP3voEt7Z5pktb5zyKtV9NHDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)