UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2RXtv0hrTHi06cB1fBv+ZSO/03lL47w40NBLyWFFPxQ='
WHERE
key_id = 'bc8f78a5facf1e47911963d6617bfcc2848e97b1035165bf500b283a55a1fec0'
AND (
token = '2RXtv0hrTHi06cB1fBv+ZSO/03lL47w40NBLyWFFPxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)